import xlrd
class Data():
    def addData(self):
        data = []
        wb = xlrd.open_workbook("测试.xls")
        ws = wb.sheet_by_index(0)
        nrows = ws.nrows
        for i in range(1,nrows):
            data.append(ws.row_values(i)[0:4])
        return data
    def subData(self):
        data = []
        wb = xlrd.open_workbook("测试.xls")
        ws = wb.sheet_by_index(1)
        nrows = ws.nrows
        for i in range(1,nrows):
            data.append(ws.row_values(i)[0:4])
        return data
    def mulData(self):
        data = []
        wb = xlrd.open_workbook("测试.xls")
        ws = wb.sheet_by_index(2)
        nrows = ws.nrows
        for i in range(1,nrows):
            data.append(ws.row_values(i)[0:4])
        return data
    def divData(self):
        data = []
        wb = xlrd.open_workbook("测试.xls")
        ws = wb.sheet_by_index(3)
        nrows = ws.nrows
        for i in range(1,nrows):
            data.append(ws.row_values(i)[0:4])
        return data

# print(Data().addData())



